/*
 * Copyright 2008-2009 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package ssn.task.service.impl;

import java.util.List;

import org.springframework.stereotype.Repository;

import ssn.task.vo.TaskVO;
import egovframework.rte.psl.dataaccess.EgovAbstractDAO;


/**  
 * @Class Name : 
 * @Description : 
 * @Modification Information  
 * @
 * @  수정일      수정자              수정내용
 * @ ---------   ---------   -------------------------------
 * 
 * @since 2013. 09.30
 * @version 1.0
 * @see
 */
@SuppressWarnings("rawtypes")
@Repository("taskDAO")
public class TaskDAO extends EgovAbstractDAO {

	public String selectTaskInfoPk() throws Exception{
		return (String)getSqlMapClientTemplate().queryForObject("selectTaskInfoPk");
	}
	public void insertTaskInfo(TaskVO vo) throws Exception{
		insert("insertTaskInfo", vo);
	}
	public void insertTaskServiceInfo(TaskVO vo) throws Exception{
		insert("insertTaskServiceInfo", vo);
	}
	public void updateTaskInfo(TaskVO vo) throws Exception{
		update("updateTaskInfo", vo);
	}
	public String selectTaskAttachFile(String sto_task_key) throws Exception{
		return (String)selectByPk("selectTaskAttachFile", sto_task_key);
	}
	public void deleteTaskAttachFile(String sto_task_key) throws Exception{
		update("deleteTaskAttachFile", sto_task_key);
	}
	public void updateTaskServiceReadTime(TaskVO vo) throws Exception{
		update("updateTaskServiceReadTime", vo);
	}
	public void updateStatusTaskInfo(TaskVO vo) throws Exception{
		update("updateStatusTaskInfo", vo);
	}
	public TaskVO selectTaskInfoAdmin(TaskVO vo) throws Exception{
		return (TaskVO)selectByPk("selectTaskInfoAdmin", vo);
	}
	public TaskVO selectTaskInfo(TaskVO vo) throws Exception{
		return (TaskVO)selectByPk("selectTaskInfo", vo);
	}
	public void deleteTaskService(String parentKey) throws Exception{
		delete("deleteTaskService", parentKey);
	}
	public List selectTaskList(TaskVO vo) throws Exception{
		return list("selectTaskList", vo);
	}
	public int selectTaskListCnt(TaskVO vo) throws Exception{
		return Integer.parseInt(selectByPk("selectTaskListCnt", vo).toString());
	}
	public List selectTaskListAdmin(TaskVO vo) throws Exception{
		return list("selectTaskListAdmin", vo);
	}
	public int selectTaskListAdminCnt(TaskVO vo) throws Exception{
		return Integer.parseInt(selectByPk("selectTaskListAdminCnt", vo).toString());
	}
	public void deleteTaskInfo(TaskVO vo) throws Exception{
		update("deleteTaskInfo", vo);
	}
}
